<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="javax.xml.transform.Result" %>
<%@ page import="com.mysql.cj.api.mysqla.result.Resultset" %>
<%@ page import="java.sql.*" %>


<%--
  Created by IntelliJ IDEA.
  User: tanfei
  Date: 2018/4/1
  Time: 22:54
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
  <title></title>
</head>
<body>
<h1>这是一个JSP文件。</h1>

<%

  out.write("<a href='addUser.jsp?'>增加</a>");
%>

<style type="text/css">
  table {
    border: 1px solid #000;
    border-collapse: collapse;
  }

  td, th {
    border: 1px solid #000;
    padding: 10px;
  }
</style>

<table>
  <thead>
  <tr>
    <th>编号</th>
    <th>用户名</th>
    <th>密码</th>
    <th>操作一</th>
    <th>操作二</th>
  </tr>
  </thead>

  <tbody>

  <%
    class User {
      int id;
      String name;
      String password;

      //alt + insert


      public User(int id, String name, String password) {
        this.id = id;
        this.name = name;
        this.password = password;
      }
    }

    List<User> list = new ArrayList<User>();
    //list.add(new User(1, "chengongsuo", "123456"));
    //list.add(new User(2, "zhen", "123456"));
    //list.add(new User(3, "John", "123456"));
    //list.add(new User(4, "Bob", "123456"));

    //3 + 1
    Connection connection =null;
    Statement statement = null;
    ResultSet resultSet =null;

    String sql = "select * from t_users";

    Class.forName("com.mysql.jdbc.Driver");

    connection = DriverManager.getConnection(
            "jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=UTC",
            "root",
            "123456"

    );

    statement = connection.createStatement();

    resultSet = statement.executeQuery(sql);

    while (resultSet.next()){
      int id = resultSet.getInt(1);
      String username = resultSet.getString(2);
      String password = resultSet.getString(3);

      User user = new User(id,username,password);
      list.add(user);
    }
    statement.close();
    resultSet.close();
    connection.close();


    for (User user : list) {

      out.write("<tr><td>" + user.id + "</td><td>" + user.name
              + "</td><td>" + user.password + "</td>" +
              "<td><a href='deleteUserHandler.jsp?id="+user.id+"'>删除</a></td>" +
              "<td><a href='updateUser.jsp?id="+user.id+"&username="+user.name+"&password="+user.password+"'>更新</a></td></tr>");
    }
  %>
  </tbody>

  <tfoot>


  </tfoot>
</table>



<!--jsp前缀-->

</body>
</html>


  $END$










































  </body>
</html>


